package com.fz.mapper;

import com.fz.entity.*;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * Created by Z-C-Y on 2018-03-06.
 * rent.jsp   艺租赁
 */
@Service
public interface WebRentMapper {
    /*显示页面图片*/
    public List<Rentimage> queryRentimage();

    /*页面大图旁边的 小商品图*/
    @Select("select * from rent")
    public List<Rent> listRent();

    /*画品分类*/
    public List<Leaseholds> queryLeaseholds();

    /*题材分类*/
    public List<Lrice> queryLrice();

    /*租赁场所*/
    public List<Peinttypes> queryPeinttypes();

    /*具体场景*/
    public List<Scene> queryScene();

    /*价格*/
    public List<Prices> queryPrices();

    //有了pageSize和startIndex，就可以拿到每页的数据
    @Select("select * from rent limit #{startIndex},#{pageSize}")
    List<Rent> queryRentData(@Param("startIndex") int startIndex, @Param("pageSize") int pageSize);


}
